# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月20日
"""
import openpyxl

myBook = openpyxl.load_workbook('收入表.xlsx')
mySheet = myBook.active
mySide=openpyxl.styles.Side(style='thick',color='FF0000')
myBorder=openpyxl.styles.Border(left=mySide,right=mySide,top=mySide,bottom=mySide)
for myRow in mySheet['A5:D8']:
	for myCell in myRow:
		myCell.border=myBorder
myBook.save('结果表-收入表.xlsx')
